Proud mother Princess Sofia, 40, who held her baby during the ceremony, brought the sunshine in a bright yellow gown and a matching headband