Drug use over the youth–adult transition in a west of Scotland cohort: prevalence, pathways and socio-demographic correlates