Rename various folders ignoring current name with Better Finder Rename
Maybe it's easier to open Terminal, go the the parent folder and run

i=0
for f in *; do
    if [[ -d "$f" ]]; then
        mv "$f" my-folders$i
        ((i=i+1))
    fi
done