Some teenagers and young adults get high on drink and drugs to improve their sex lives, research suggests.