Survey shows 84 per cent of Scots want the country to keep extracting fossil fuels