The chancellor has pledged the "largest settlement in real terms since devolution" for Scotland as part of the UK government's spending review.