The number of people diagnosed rose from 190,772 to 267,615 between 2008 and 2018, a study by Diabetes Scotland shows.