Scotland’s First Minister John Swinney has been “spooked” into scrapping his party’s opposition to more oil and gas fields in the North Sea because of fears of losing seats in the Holyrood Parliament.