The Virginia police officer who was filmed pepper-spraying a uniformed Black Army officer after holding him at gunpoint has been fired