A ban on football supporters drinking alcohol in the stands is discriminatory, unfair and should be scrapped, the prime minister has said.