No. Not simply just paying it off. As long as the collection is on your record, it's a MAJOR derogatory. Paid or unpaid.
Now negotiating for a "pay for delete" is another matter. Many here have used that tactic(myself included) used it with success and had the entire record deleted which caused a major score rise.