People born in the 1960s and 70s stand out as the generation most likely to die by suicide or drug poisoning, data shows.