North-east jobs at risk over calls to end oil and gas with ‘flick of the switch’