Table p_sent_notifications table shares sequence

What does this MR do and why?

We will soon be inserting records into the p_sent_notifications table. So, when we make the switch, we need to make sure new record ids don't collide with those inserted by the sync trigger installed on the original sent_notifications table.

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #514591 (closed)