In fan footage uploaded on X, the pop diva wished little Sir and his fraternal twin sister Rumi Carter a happy eighth birthday while onstage