A consultation on the future of the North Sea has launched at a critical time for the sector.