A new museum in the UK housing the last ever Concorde to be built and to fly has opened to the public for the first time.