It had its supporters and detractors, but it was a bold design crafted during the birth of the space age. Now, the last of the Concordes perches flightless at the National Museum of Scotland. Will we ever see a passenger aircraft with such verve again?