There is growing optimism that UK North Sea exploration drilling has turned a corner after several lean years, with more high-impact prospects arriving