More relevant is that drag goes up with the square of speed generally... in the subsonic regime... I'm not sure what happens across the sound barrier, but I believe it gets worse.
There is a wikipedia article on the topic (of course): https://en.wikipedia.org/wiki/Fuel_economy_in_aircraft
"Concorde, a supersonic transport, managed about 17 passenger-miles to the Imperial gallon, which is 16.7 L/100 km per passenger; similar to a business jet, but much worse than a subsonic turbofan aircraft. Airbus states a fuel rate consumption of their A380 at less than 3 L/100 km per passenger"
But the real comparison should not be between subsonic and supersonic trans-ocean business trips. It should be between taking the trip or not taking the trip at all. The best way to reduce emissions is to avoid long-distance air travel completely.
This is why your airliner is about 100 to 150 mpg per passenger but a container vessel is 1000mpg per tonne of cargo.