Barack Obama has told a powerful Israeli lobby that a deal between Israelis and Palestinians should be on the basis of the 1967 borders.