David Cameron is promising a North Sea oil revolution but only if Scotland stays part of the union