US president leads nation in moment of silence in honour of victims of a weekend shooting in Arizona that left six dead.