Describe the feature

AppRunner supports Auto-Scaling configuration management.
https://aws.amazon.com/about-aws/whats-new/2023/09/aws-app-runner-auto-scaling-management/

L1 Construct already supported, but current L2 Construct does not support.

Use Case

To use auto-scaling for AppRunner Service.

Proposed Solution

• Add AutoScalingConfiguration class.
• Add autoscaling property to the Service class.

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.143.0

Environment details (OS name and version, etc.)

All