Billions of barrels of “black gold” have been pumped by the North Sea oil industry from rocks below Scotland’s waters in the last 50 years, but now the UK nation is looking