More than half a century after William Friedkin’s revolutionary action film stunned viewers, Geoffrey Macnab looks at how the rogue cop at its centre manages to be so perversely sympathetic