Viewers were in floods of tears after Sir Paul performed on Saturday Night Live