How to rename all .sql files in a folder to have a new running sequence using PowerShell

$files = Get-ChildItem -Path . -Filter “*.sql”
$counter = 5
foreach ($file in $files) {
$newName = “{0:D2}-$file” -f $counter
Rename-Item -Path $file.FullName -NewName $newName
$counter++
}

Original sql files in a folder

After execution of above script, files are renamed.