The emotional moment was captured by a fan who shared a clip to X, with music lovers rushing to the comments to share how it made them feel