Brexit is likely to affect the UK oil and gas sector, says professor at Robert Gordon University.