The former chair of the North Sea Transition Authority, Tim Eggar, has been awarded a CBE in the New Year Honours List for services to energy.