A UK parliamentary inquiry has called on the government to support ambitious plans to ensure a long-term future for the North Sea oil and gas industry.