Proposal: As Go 1.23 introduced `iter`, we could consider to provide `iter` based `Scan` method (called `Iter()` or others)

- [x] I have searched the [issues](https://github.com/ent/ent/issues) of this repository and believe that this is not a duplicate.

## Summary 💡

From the user side, the signature cloud be

```go
func (...) Scan(ctx context.Context, v any) error

func (...) Iter(ctx context.Context) iter.Seq[Row]
```

## Motivation 🔦