Nearly 1,200 people died of drug-related deaths in Scotland last year, the highest ever total.