The Scottish singer-songwriter legend is celebrating his 1966 #1 hit “Sunshine Superman” with a return performance to NYC’s Carnegie Hall, among many dates