The Scottish Government is being urged to give its 'full-throated support' to North Sea oil and gas