Why does the USS Enterprise always have the same registry number?

Is there any in universe explanation as to why the Enterprise always gets to keep its 1701 registry number?

Also I don't recall any other starships from the TNG, DS9, Voyager time period that had this honor bestowed on it. Certainly Captain Sisko's second USS Defiant would have been worthy of it.