Approvals for manual pipeline actions

Description

Use-case:

Teams who do not use a feature branching system, but instead us the master branch with tags. They would like to have the added security of an approval for things such as a production deployment.

Links / references

Customer Ticket -> https://gitlab.zendesk.com/agent/tickets/90085 (internal only)