Oil and gas exploration is back and deepwater sweet spots are attracting the most attention, energy intelligence group Wood Mackenzie’s industry survey has shown.