A Bury police officer has been sacked after he made a racist remark about a black officer last year.