More than seven in 10 Scots back drilling in the North Sea to reduce the country’s reliance on foreign imports, a survey has found.