Add ID columns to the observation tables

What does this MR do?

This MR adds a primary key id column to each project's observation table using a flyway migration.

Why is this MR needed?

Accessing observations using STA is extremely slow, because of the dynamic generation of id values. With this MR, we add an id column to the base table observation that is then referenced in the STA views "OBSERVATIONS".

How to test this MR?

• setup a fresh system including observation data with ./tsm-workflow.sh down clear upfast populate upload sms within the tsm-dev-tools
• checkout the branch add-observation-id in tsm-orchestration
• restart the system with ./tsm-workflow.sh down upfast in tsm-dev-tools
• connect to the local database and check for an id column in the observation tables.

⚠️

Do not change the auto-generated Merge commit message or Squash commit message, otherwise the release pipeline fails!