This would need to be done at the client level, which means you would see some clients implement it while others don't. As far as Nostr as a protocol is concerned, when a user updates their profile note (kind 0) relays are permitted (and expected) to delete any previous version.