Paul McCartney in Liverpool pub

As homecoming gigs for one of the world’s biggest rock stars go, it was fairly low key: a small band on a slightly bigger stage in a local pub.

But for the drinkers who just happened to be in the Philharmonic Dining Rooms in Liverpool, seeing Sir Paul McCartney perform was probably the best gig of their lives.

There was amazement, dancing and more than a few tears when one of Liverpool’s most celebrated sons returned for his appearance on The Late Late Show’s Carpool Karaoke with James Corden on Tuesday.

McCartney performed a piano rendition of When I’m Sixty-Four as he revisited his childhood home, showing Corden the back room where he wrote songs with fellow Beatle John Lennon. Walking upstairs in the small terrace, he showed off his old “acoustic chamber” – the toilet where he would sit, strum and sing for hours.

Describing how he and Lennon had played She Loves You to his father, McCartney recalls him asking if they could change the refrain to “yes, yes, yes” because there were already too many Americanisms in common use. “We did not heed his advice. Had we have done, who knows what could have happened,” he said.

Tweeting a link to the episode, Corden wrote: “Ok, so here it is. Quite possibly the best #CarpoolKaraoke we’ve done so far. I hope you like it. I’ll never ever forget it. Take a breath and jump in.”

The pair started the show singing the Beatles hit Drive My Car, while cruising through the city, replacing the song’s “beep beeps” with honks of the horn. On Penny Lane, they popped into a barber shop – which had a picture on the wall of a much younger McCartney getting his hair cut – much to the delight of the hairdresser.

Corden became emotional as the pair sang Let It Be in the car. “I can remember my granddad, who’s a musician, and my dad sitting me down and saying, ‘We’re going to play you the best song you’ve ever heard’. And I remember them playing me that. If my granddad was here right now, he’d get an absolute kick out of this,” Corden said. “That’s the power of music,” McCartney replied.