Former officer who asked for a suspect's sex video to show "the lads from footy" is jailed for four years.