Oil production in the South of England could add billions to the economy and help offset the decline in North Sea production, a report says.