The CEO of United Airlines has apologised for the "truly horrific" incident in which a passenger was forcibly dragged, screaming, from a flight due to overbooking.