A new £40m terminal was opened by Queen Elizabeth II and Prince Philip in 1999