Douglas Ross’s Conservatives have been punished by voters over Downing Street parties and the cost-of-living crisis, as the SNP surged to victory in local authorities across Tayside and Fife.