The fate of a prop from Glasgow's 2026 Commonwealth Games Opening Ceremony has been revealed after it was sold at auction.