The North Sea could lead the way on energy transition as an increasing number of low carbon solutions grow in prominence in the mature basin