The report shows soaring gas prices cost Scottish households an additional £5.8 billion between 2021-24.