Scotland’s deficit has risen by more than £4.5 billion in the past year, as North Sea oil and gas revenues have halved, according to recent data.