Scotland’s block grant has fallen to its lowest share of UK Government spending in nearly a decade, a report has found.