Well, some people don't want others to be offended. Knowing that what they'll say will likely offend someone, saying no offense will let them know that they're about to say something offensive, whether they're offended or not. I usually just see it as a warning signal, like "Hey, I'm going to say something that may offend you."