Young people are rejecting alcohol – with abstinence almost doubling in a decade, a study suggests.