The plan to drill for oil deep under the sea at Cambo, north west of Shetland, is “uneconomic” and would breach international targets to cut climate pollution.