North east oil and gas industry ‘economic force for good’, according to survey