Although Scotland enjoys public spending well above the UK average – a source of resentment among some in England, Wales and Northern Ireland – the cost to the Treasury is more than outweighed by oil and gas revenues from Scottish waters.