A police officer shouted at a member of the public walking down a street after the Sheffield derby to “f--- off”.