Pyiceberg StaticTable use the last metadata json URL when the full path is not provided

### Feature Request / Improvement

when I write something like this, I expect pyicberg to pick the last metadata json file.

```
from pyiceberg.table import StaticTable
table = StaticTable.from_metadata(
"s3://yyyyyyyy/iceberg/metadata"    
)
```

### Query engine

Other