Paddy McGuinness has raised more than £9 million following his charity bike ride for BBC Children in Need.