US President Barack Obama has condemned the killing of two New York police officers by a man who then turned his gun on himself.