Add destructive action guidelines in button order

As a follow up from gitlab-org/gitlab!57172 (comment 535911399), this is to add documentation on keeping destructive actions separate from confirmation actions in cases where they are in the same container.

Button order docs: https://design.gitlab.com/components/button#order