Offshore energy fueled Scotland’s dream of independence. The eclipse of North Sea oil and gas is killing it.