Yeah, I know what you are talking about, and that sound is supposed to be the sound of a needle being scratched across a vinyl record.
Whether that's the way they actually produce it or not is another question. Foley artists are an amazingly clever lot.