Was generative AI tooling used to co-author this PR?

• No

closes: #63809

When materializing an asset via CLI command: airflow assets materialize, the created DAG run had run_type=MANUAL which is a bug. UI did it properly and had it as ASSET_MATERIALIZATION, so rectifying this behaviour in CLI to match UI.

I updated trigger_dag() helper to accept an optional run_type parameter (defaulting to MANUAL for backward compatibility), allowing call sites to specify the correct run type or not for default.

Run id is also updated for consistency.

Working here:

First one is after the fix, Second one before the fix (both CLI), and third one is from UI

• Read the Pull Request Guidelines for more information. Note: commit author/co-author name and email in commits become permanently public when merged.
• For fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
• When adding dependency, check compliance with the ASF 3rd Party License Policy.
• For significant user-facing changes create newsfragment: {pr_number}.significant.rst, in airflow-core/newsfragments. You can add this file in a follow-up commit after the PR is created so you know the PR number.