Video shows the scene where a Virginia man was fatally shot on the Upper West Side in broad daylight Sunday