Getting error in Table column contains a duplicate value, during incremental refresh

Will it happen if that unique ID is present in archived data and got updated in a recent refresh 

Yes, it will. Remember this is incremental refresh, not differential refresh.  Incremental refresh only works with immutable data, If your data is mutable you need to manually refresh all affected partitions.