The group behind Aberdeen, Glasgow and Southampton airports is being sold in a deal worth more than £1.53 billion, it has been announced.