feat: add DELETE /opportunities/:id endpoint

[josephtd]

Summary

Add a DELETE endpoint to remove an opportunity by ID.

Acceptance Criteria

• DELETE /opportunities/:id returns 204 on success
• Returns 404 if the opportunity does not exist
• Unit tests cover both cases