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.