The Princess of Wales' brother has described the moment he and Pippa heard about her engagement ahead of the public announcement