Scots living in the worst deprivation and poverty are bearing the brunt of the increase in illness over the past 12 years, experts warn.