The CEO of United Airlines has apologised for the "truly horrific" removal of a passenger from an overbooked flight.