Kate Middleton's sister unexpectedly stole the show in her fitted bridesmaid dress while walking behind the bride at the royal wedding