Scotland has the highest rate of drugs deaths in Europe, with fatalities rising by 12 in a year to 1,172 drug-related deaths in 2023.