Raising tax on North Sea oil and gas profits could “kill the goose that lays the golden egg” and threaten the transition to net zero, an MP has warned.