‘Energy transition vital’ as oil and gas workforce set to shrink by more than 2,000 in next five years