The “sweet spot” appears to be drinking one to six units of alcohol per week, researchers say.