First time using regex, looking for some assistance on how to write the syntax for get the following

This is the syntax that I have '.*(\d{6,}).*', '$1') but it doesn't give me my desired results. I'm not sure how or where I can adjust.
THANKS FOR THE HELP!