Sir Paul McCartney was named the "Ultimate Legend" at a prestigious awards ceremony in his home city.
